package com.sdjzu.university.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sdjzu.university.entity.University;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface UniversityMapper extends BaseMapper<University> {
    @Select("select * from university")
    List<University> selectList();

    @Insert("insert into university values (100,'济南大学','济南',510,'150654',10000)")
    int insert();

    @Update("update university set universitybottom = 522 where universityName = '山东建筑大学'")
    int update();

    @Delete("delete from university where universityId = 100")
    int delete();
}
